The Database API > Database API functions > MMDB.getTables()

 

MMDB.getTables()

Availability

Dreamweaver UltraDev 1.0

Description

Gets a list of all the tables defined for the specified database. Each table object has three properties: table, schema, and catalog. Table is the name of the table, schema is the name of the schema containing the table, and catalog is the catalog containing the table.

Arguments

connName

connName is an UltraDev connection name as specified in the Connection Manager. It is used to make a database connection to a live data source.

Returns

An array of objects; each object has three properties: table, schema, and catalog.

Example

The statement MMDB.getTables ("EmpDB"); might produce an array of two objects. The first object's properties might be the following:

object1[table:"Employees", schema:"personnel", catalog:"syscat"]

The second object's properties might be the following:

object2[table:"Departments", schema:"demo", catalog:"syscat2"]